Date queries can be made using a variety of date formats and separators.
Use the following date formats to execute queries in ODBC.
| Date Format | Example |
|---|---|
|
MonthName/Day/Year |
February/14/2022 |
|
Day/MonthName/Year |
14/February/2022 |
|
Year/Month/Day |
2022/02/14 |
Use the following date separators: forward slash ("/"), dash ("-"), space (" "), and colon (":"). Various separators have equivalent value, so '2022/02/14' = '2022-02-14' = '2022 02 14' = '2022:02:14'.
Example
|
SELECT * FROM mysite_uis.realtimevalues WHERE Time = '2022/02/14' |
|
|
|